# -*- coding: utf-8 -*-
# standard
import os
import sys
from typing import List

# third
import orjson

# local
_P_PATH =  os.path.dirname(os.path.dirname(os.path.realpath(__file__)))
if _P_PATH not in sys.path:
    sys.path.append(_P_PATH)
from functions import *

"""
@Title:   
@File: temp.py
@Author: walle 2023年10日16日 15时52分07秒
@Version: 1.0.0
@Desc: 
"""

KEYS = [
"u9GEmyZ8B3Q",
"u9hauSrihYQ",
"uHs2Auz5s6w",
"uJZWcKOIZMo",
"uaB6Bdgp3WU",
"uarlIjkHlAs",
"ufp5iGh0agA",
"ulLFP8axZVQ",
"umKKrbmdHFM",
"unSnvLgyf3o",
"v7xAZ2lrel8",
"v9dEgXR1iWE",
"vCCdmGKtxPA",
"vFPkEIGUofc",
"vGzBcBZrOSw",
"vNyZmSg92HI",
"vRK7KKQH9Ck",
"vYV4tAq3wVg",
"vbKKoniUxMk",
"vg8WAv0YT9c",
"vhfcedpoCLo",
"vkEeNkHilIg",
"vlj9aPKB9m0",
"vo2cse4CoGM",
"voXOUWiJuLo",
"vqqWw3xkMzA",
"vrU6YJle6Q4",
"vzKA1y3cdYI",
"vzi4AopBEBg",
"w32u2NwCve0",
"w3q89BTJj3o",
"w7rewjFNiys",
"wCf62ksaplI",
"wDkH7Qpu6V4",
"wJttdkKo4nM",
"wJxSRo564Dc",
"wKIHuxe2fi0",
"wMWYLgj1ydw",
"wOiKRVH0nQ8",
"wQJC2MMB8nA",
"wSF82AwSDiU",
"wUKAVcj9NVA",
"wa7H1A81bdM",
"wcMnmCH6Gjg",
"wcWD7fERQCc",
"weCFbknwZa8",
"wmE8dQcZgB4",
"ws4GZvNeQhQ",
"wstksuaSMD4",
"wtvhqeVoeqI",
"ww4kNxYE0c4",
"x4m6j7rSyzY",
"xDe346z233Y",
"xGGtRQ3wCB4",
"xHQbg4xH9lw",
"xLuMcYn8Yk0",
"xP4w2DMscGw",
"xRdZXhyrO6c",
"xT8UwfwkCaY",
"xTBYcSL3MrI",
"xY7kVVS2HVY",
"xb4nTtpvDF4",
"xbWcLYOniWU",
"xbagFzcyNiM",
"xeFl0RE31x0",
"xfDUGqGPSfo",
"xgKqX5Yj3b8",
"xjSQFZX2m9o",
"xlngY8QCEt0",
"xnovQVRHj5c",
"xossR6eHv3I",
"xpfxVRBddNQ",
"xpnFeyMGUs8",
"xqPJKtFI42U",
"xx310zM3tLs",
"y2X7c9TUQJ8",
"y3ZrjRlIcgI",
"y6FT80ZoVJY",
"y7A4dZIyI0g",
"y7LXwGfvxwo",
"y8ZMviYx9aY",
"yA9xQB547Yo",
"yLjxoscCi0A",
"yRUCU5FsvTY",
"yVQ8fZB30JU",
"yXTtHmj1sr0",
"yqc9zX04DXs",
"yyW9W3e9VD0",
"zGEDHMF4rLI",
"zISxg4JhSRk",
"zmDENxTPn8Q",
"zw9NXY3xOOI",
"rGgoCm1hofM",
"H682jmofwZs",
"Jm2dWbNsnZI",
"OH0dK208MNk",
"49aWAHqi200",
"6YKYo00mFAg",
"6gSwRHScq6M",
"78nsxRxbf4w",
"7SfRgg9botI",
"7sxpKhIbr0E",
"855Now8h5Rs",
"8m5Ebx6nuGE",
"9XRPbFIN4lk",
"AAkEYcmCCCk",
"ARWBdfWpDyc",
"AlCqyZEXM1I",
"CE3tL9MMk3U",
"FmpIMt95ndU",
"G2Y6Am46eVU",
"0JGarsZE1rk",
"0snNB1yS3IE",
"0z03xkwFbw4",
"1xgCI05l2GA",
"2K6P014XXmQ",
"2Oe6HUgrRlQ",
"2Pp9ONyxBr8",
"3E46oWB4V0s",
"ytJyT9oDEm4",
"yxC30tEjZk8",
"zWxFhFZJDks",
"zuAj2F54bdo",
"GigYWy2UmOY",
"uVAaZVz9pDs",
"y8ip1mQovVI",
"yA1O5gmP4eg",
"yg8SBuTuoKk",
"yioZhHe1i5M",
"yldVmMfMyIg",
"yoAqA6vgnCQ",
"yqU0SsbENgE",
"yuu6o4AQwNI",
"yyemG7V5ynQ",
"z1KJAXM3xYA",
"z4eSa6GXEsE",
"z4vmzTZ7qLA",
"z5lZ9wciZQM",
"z9CabT4Kcz8",
"z9sa2ZAqHl0",
"zAFcV7zuUDA",
"zDcaoTVy4fA",
"zESeeaFDVSw",
"zL2FOrx41N0",
"zPHOvuZmCG4",
"zR8ReJoc1u4",
"zWU9D2duSgs",
"zXCiv4sc5eY",
"zYhgy5ouYLM",
"zbHe4RpgV80",
"zeSVMG4GkeQ",
"zpoGgUoqkkQ",
"znO7UHpxgTI",
"zwjLQgNd7XM",
"0zvrGiPkVcs",
"UOo13qXVdy4",
"zpNBwNgWejs",
"zvvZEIGNLo0",
]


def main():
    """
    xRdZXhyrO6c, xRdZXhyrO6c 缺少对应的音频文件
    UOo13qXVdy4, ChunkedEncodingError
    """
    db_session = new_db_session()
    query = db_session.query(MediaFileOrm).filter(MediaFileOrm.key.in_(KEYS))
    for x in query:
        print(f"{x.key}, {x.error}, {x.audio_path}")




if __name__ == '__main__':
    main()
    pass